SySEVISSiteOfActivity 
Logical Entity Name  SySEVISSiteOfActivity 
Default Table Name  SySEVISSiteOfActivity 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

SySEVISSiteOfActivity Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SyCampusID(FK)    int  NO 
 
SyStudentID(FK)    int  NO 
 
Active    bit  NO 
 
ts    timestamp  NO 
 
SySEVISSiteofActivityID(PK)    int  NO 
 

SySEVISSiteOfActivity Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_SySEVISSiteofActivity  PrimaryKey  SySEVISSiteofActivityID 
SySEVISSiteOfActivity_SyCampusID_SyStudentID_Active_U_C_IDX  Index  SyCampusID, SyStudentID, Active 

SySEVISSiteOfActivity Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
SyCampus  Non-Identifying  One To Zero or More  FK_SySEVISSiteOfActivity_SyCampusID_SyCampus_SyCampusID      SyCampusID  NO  YES 
syStudent  Non-Identifying  One To Zero or More  FK_SySEVISSiteOfActivity_SyStudentID_syStudent_SyStudentID      SyStudentID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

SySEVISSiteOfActivity Check Constraints 
Check Constraint Name  CheckConstraint 

SySEVISSiteOfActivity Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  C2000_Index 
Text Image File Group   

SySEVISSiteOfActivity Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.SevisStudentSiteActivity 
NO       
Physical (Microsoft SQL Server)
dbo.SySEVISSiteOfActivity 
NO       

SySEVISSiteOfActivity Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  SEVIS 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  SEVIS 

SySEVISSiteOfActivity Data Movement Rules 
Name  Type  Rule Text/Value